using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VMAPCON
    {
        public DataSet QMAPCON01(DataRow dwData)
        {

            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT utl_raw.cast_to_varchar2(MCKONSTLST1) AS KONSTLST1, utl_raw.cast_to_varchar2(MCKONSTLST2) AS KONSTLST2, utl_raw.cast_to_varchar2(MCZZUSTAB1) AS ZZUSTAB1, "
                +"utl_raw.cast_to_varchar2(MCZZUSTAB2) AS ZZUSTAB2, utl_raw.cast_to_varchar2(MCZZUSTAB3) AS ZZUSTAB3,P.* FROM MAPCON P"
                + " WHERE  MCMANDANT=:MCMANDANT: AND MCNAME=:MCNAME: AND MCSPRKZ=:MCSPRKZ:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
    }
}
